Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	1276
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	670.2 KiB
Average record size in memory	537.9 B

Variable types

NUM	15
CAT	5
UNSUPPORTED	1

Reproduction

Analysis started	2021-02-27 20:32:15.741948
Analysis finished	2021-02-27 20:32:49.741912
Duration	34 seconds
Version	pandas-profiling v2.7.1
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

`title` has a high cardinality: 1268 distinct values	High cardinality
`deltaMedianPrice` is highly correlated with `deltaAvgPrice`	High correlation
`deltaAvgPrice` is highly correlated with `deltaMedianPrice`	High correlation
`dublinNorthSouth` is highly correlated with `neighbourhood`	High correlation
`neighbourhood` is highly correlated with `dublinNorthSouth`	High correlation
`title` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`floorArea` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`deltaMedianPrice` has 46 (3.6%) zeros	Zeros

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct count	1276
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1473.0634796238244
Minimum	0
Maximum	2962
Zeros	1
Zeros (%)	0.1%
Memory size	10.1 KiB

Quantile statistics

Minimum	0
5-th percentile	208.75
Q1	810.75
median	1478.5
Q3	2122
95-th percentile	2761.25
Maximum	2962
Range	2962
Interquartile range (IQR)	1311.25

Descriptive statistics

Standard deviation	795.7762134
Coefficient of variation (CV)	0.5402185476
Kurtosis	-1.058014595
Mean	1473.06348
Median Absolute Deviation (MAD)	653
Skewness	0.03477867836
Sum	1879629
Variance	633259.7818

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	1	0.1%
1324	1	0.1%
1339	1	0.1%
1338	1	0.1%
1335	1	0.1%
1332	1	0.1%
1331	1	0.1%
1326	1	0.1%
1325	1	0.1%
1323	1	0.1%
Other values (1266)	1266	99.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
9	1	0.1%
11	1	0.1%
14	1	0.1%
16	1	0.1%

Value	Count	Frequency (%)
2962	1	0.1%
2960	1	0.1%
2958	1	0.1%
2956	1	0.1%
2950	1	0.1%

title
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	1268
Unique (%)	99.4%
Missing	0
Missing (%)	0.0%
Memory size	10.1 KiB

20 Moyclare Road, Baldoyle, Dublin 13	2
24 The Wood, Millbrook Lawns, Tallaght, Dublin 24	2
Apartment 101, Milltown Hall, Milltown Avenue, Mount Saint Annes, Milltown, Dublin 6	2
26 Grace Park Court, Beaumont Road, Beaumont, Dublin 9	2
171 Drimnagh Road, Drimnagh, Dublin 12	2
Other values (1263)	1266

Value	Count	Frequency (%)
20 Moyclare Road, Baldoyle, Dublin 13	2	0.2%
24 The Wood, Millbrook Lawns, Tallaght, Dublin 24	2	0.2%
Apartment 101, Milltown Hall, Milltown Avenue, Mount Saint Annes, Milltown, Dublin 6	2	0.2%
26 Grace Park Court, Beaumont Road, Beaumont, Dublin 9	2	0.2%
171 Drimnagh Road, Drimnagh, Dublin 12	2	0.2%
Apartment 427, The Old Chocolate Factory, Kilmainham Square, Kilmainham, Dublin 8	2	0.2%
20 Muckross Green, Perrystown, Dublin 12	2	0.2%
88 Scholarstown Park, Rathfarnham, Dublin 16	2	0.2%
141 Collinswood, Collins Avenue, Beaumont, Dublin 9	1	0.1%
Apartment 84, The William Bligh, The Gasworks, Dublin 4	1	0.1%
Other values (1258)	1258	98.6%

Length

Max length	84
Mean length	45.11755486
Min length	22

Value	Count	Frequency (%)
Lowercase_Letter	27	38.0%
Uppercase_Letter	25	35.2%
Decimal_Number	10	14.1%
Other_Punctuation	4	5.6%
Dash_Punctuation	1	1.4%
Space_Separator	1	1.4%
Close_Punctuation	1	1.4%
Connector_Punctuation	1	1.4%
Open_Punctuation	1	1.4%

Value	Count	Frequency (%)
Latin	52	73.2%
Common	19	26.8%

Value	Count	Frequency (%)
ASCII	70	100.0%

neighbourhood
Categorical

HIGH CORRELATION

Distinct count	22
Unique (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	10.1 KiB

Dublin 15	123
Dublin 11	100
Dublin 8	97
Dublin 3	81
Dublin 9	80
Other values (17)	795

Value	Count	Frequency (%)
Dublin 15	123	9.6%
Dublin 11	100	7.8%
Dublin 8	97	7.6%
Dublin 3	81	6.3%
Dublin 9	80	6.3%
Dublin 4	77	6.0%
Dublin 14	73	5.7%
Dublin 24	71	5.6%
Dublin 7	71	5.6%
Dublin 12	67	5.3%
Other values (12)	436	34.2%

Length

Max length	9
Mean length	8.536050157
Min length	8

Value	Count	Frequency (%)
Decimal_Number	10	55.6%
Lowercase_Letter	5	27.8%
Uppercase_Letter	2	11.1%
Space_Separator	1	5.6%

Value	Count	Frequency (%)
Common	11	61.1%
Latin	7	38.9%

Value	Count	Frequency (%)
ASCII	18	100.0%

propertyType
Categorical

Distinct count	10
Unique (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	10.1 KiB

Apartment	395
Terrace	341
Semi-D	283
End of Terrace	113
Detached	67
Other values (5)	77

Value	Count	Frequency (%)
Apartment	395	31.0%
Terrace	341	26.7%
Semi-D	283	22.2%
End of Terrace	113	8.9%
Detached	67	5.3%
Duplex	32	2.5%
Bungalow	18	1.4%
Site	14	1.1%
Townhouse	12	0.9%
Studio	1	0.1%

Length

Max length	14
Mean length	8.043887147
Min length	4

Value	Count	Frequency (%)
Lowercase_Letter	19	70.4%
Uppercase_Letter	6	22.2%
Dash_Punctuation	1	3.7%
Space_Separator	1	3.7%

Value	Count	Frequency (%)
Latin	25	92.6%
Common	2	7.4%

Value	Count	Frequency (%)
ASCII	27	100.0%

numBedrooms
Real number (ℝ)

Distinct count	9
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.6120689655172415
Minimum	-1.0
Maximum	11.0
Zeros	0
Zeros (%)	0.0%
Memory size	10.1 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	2
median	3
Q3	3
95-th percentile	4
Maximum	11
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.024780852
Coefficient of variation (CV)	0.3923253426
Kurtosis	5.042710271
Mean	2.612068966
Median Absolute Deviation (MAD)	1
Skewness	0.4144378527
Sum	3333
Variance	1.050175794

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3	518	40.6%
2	464	36.4%
4	131	10.3%
1	103	8.1%
5	38	3.0%
-1	15	1.2%
6	4	0.3%
7	2	0.2%
11	1	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	15	1.2%
1	103	8.1%
2	464	36.4%
3	518	40.6%
4	131	10.3%

Value	Count	Frequency (%)
11	1	0.1%
7	2	0.2%
6	4	0.3%
5	38	3.0%
4	131	10.3%

numBathrooms
Real number (ℝ)

Distinct count	7
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.6316614420062696
Minimum	-1.0
Maximum	6.0
Zeros	0
Zeros (%)	0.0%
Memory size	10.1 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	6
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8535420445
Coefficient of variation (CV)	0.5231122232
Kurtosis	2.260186109
Mean	1.631661442
Median Absolute Deviation (MAD)	1
Skewness	0.7076769502
Sum	2082
Variance	0.7285340218

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	629	49.3%
2	454	35.6%
3	146	11.4%
4	22	1.7%
-1	18	1.4%
5	5	0.4%
6	2	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	18	1.4%
1	629	49.3%
2	454	35.6%
3	146	11.4%
4	22	1.7%

Value	Count	Frequency (%)
6	2	0.2%
5	5	0.4%
4	22	1.7%
3	146	11.4%
2	454	35.6%

floorArea
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	10.1 KiB

price
Real number (ℝ_≥0)

Distinct count	188
Unique (%)	14.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	396152.03761755483
Minimum	75000.0
Maximum	2500000.0
Zeros	0
Zeros (%)	0.0%
Memory size	10.1 KiB

Quantile statistics

Minimum	75000
5-th percentile	199000
Q1	260000
median	349000
Q3	450000
95-th percentile	795000
Maximum	2500000
Range	2425000
Interquartile range (IQR)	190000

Descriptive statistics

Standard deviation	220609.2038
Coefficient of variation (CV)	0.556880144
Kurtosis	21.38536286
Mean	396152.0376
Median Absolute Deviation (MAD)	94000
Skewness	3.425419534
Sum	505490000
Variance	4.866842079e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
275000	43	3.4%
350000	40	3.1%
250000	35	2.7%
375000	34	2.7%
395000	33	2.6%
450000	31	2.4%
295000	31	2.4%
425000	30	2.4%
325000	29	2.3%
260000	29	2.3%
Other values (178)	941	73.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
75000	1	0.1%
95000	1	0.1%
135000	2	0.2%
139000	1	0.1%
140000	3	0.2%

Value	Count	Frequency (%)
2500000	2	0.2%
2300000	1	0.1%
1800000	1	0.1%
1700000	1	0.1%
1600000	2	0.2%

rating
Categorical

Distinct count	16
Unique (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	10.1 KiB

D2	168
D1	157
C3	129
C2	122
C1	107
Other values (11)	593

Value	Count	Frequency (%)
D2	168	13.2%
D1	157	12.3%
C3	129	10.1%
C2	122	9.6%
C1	107	8.4%
E1	103	8.1%
E2	92	7.2%
B3	90	7.1%
F	76	6.0%
G	67	5.3%
Other values (6)	165	12.9%

Length

Max length	6
Mean length	2.079937304
Min length	1

Value	Count	Frequency (%)
Uppercase_Letter	10	66.7%
Decimal_Number	4	26.7%
Connector_Punctuation	1	6.7%

Value	Count	Frequency (%)
Latin	10	66.7%
Common	5	33.3%

Value	Count	Frequency (%)
ASCII	15	100.0%

sellerId
Real number (ℝ_≥0)

Distinct count	191
Unique (%)	15.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5651.622257053292
Minimum	7
Maximum	11902
Zeros	0
Zeros (%)	0.0%
Memory size	10.1 KiB

Quantile statistics

Minimum	7
5-th percentile	12
Q1	1367
median	6498
Q3	9737
95-th percentile	11062
Maximum	11902
Range	11895
Interquartile range (IQR)	8370

Descriptive statistics

Standard deviation	4231.153412
Coefficient of variation (CV)	0.7486617504
Kurtosis	-1.666174779
Mean	5651.622257
Median Absolute Deviation (MAD)	4441
Skewness	-0.04532335691
Sum	7211470
Variance	17902659.19

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
11062	46	3.6%
10947	43	3.4%
11	40	3.1%
7569	35	2.7%
1413	33	2.6%
12	31	2.4%
8505	31	2.4%
6498	25	2.0%
9172	24	1.9%
10949	23	1.8%
Other values (181)	945	74.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	6	0.5%
11	40	3.1%
12	31	2.4%
49	14	1.1%
56	8	0.6%

Value	Count	Frequency (%)
11902	4	0.3%
11766	6	0.5%
11754	1	0.1%
11720	2	0.2%
11635	1	0.1%

longitude
Real number (ℝ)

Distinct count	1242
Unique (%)	97.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-6.280365709914858
Minimum	-6.443882
Maximum	-6.055211
Zeros	0
Zeros (%)	0.0%
Memory size	10.1 KiB

Quantile statistics

Minimum	-6.443882
5-th percentile	-6.40275325
Q1	-6.32030875
median	-6.2762445
Q3	-6.235324
95-th percentile	-6.16926
Maximum	-6.055211
Range	0.388671
Interquartile range (IQR)	0.08498475

Descriptive statistics

Standard deviation	0.07048235548
Coefficient of variation (CV)	-0.01122265147
Kurtosis	-0.009692856351
Mean	-6.28036571
Median Absolute Deviation (MAD)	0.0417385
Skewness	-0.07827101505
Sum	-8013.746646
Variance	0.004967762435

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-6.227282	3	0.2%
-6.309374	3	0.2%
-6.249849	2	0.2%
-6.255195	2	0.2%
-6.25762	2	0.2%
-6.146247	2	0.2%
-6.275658	2	0.2%
-6.27907	2	0.2%
-6.313029	2	0.2%
-6.392492	2	0.2%
Other values (1232)	1254	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-6.443882	1	0.1%
-6.443585	1	0.1%
-6.442693	1	0.1%
-6.441123	1	0.1%
-6.440754	1	0.1%

Value	Count	Frequency (%)
-6.055211	1	0.1%
-6.059735	1	0.1%
-6.060574	1	0.1%
-6.065742	1	0.1%
-6.066756	1	0.1%

latitude
Real number (ℝ_≥0)

Distinct count	1241
Unique (%)	97.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	53.3437929335963
Minimum	53.21904
Maximum	53.433172
Zeros	0
Zeros (%)	0.0%
Memory size	10.1 KiB

Quantile statistics

Minimum	53.21904
5-th percentile	53.27083575
Q1	53.31776925
median	53.34541
Q3	53.38014125
95-th percentile	53.400625
Maximum	53.433172
Range	0.214132
Interquartile range (IQR)	0.062372

Descriptive statistics

Standard deviation	0.04162785884
Coefficient of variation (CV)	0.0007803693092
Kurtosis	-0.6607437934
Mean	53.34379293
Median Absolute Deviation (MAD)	0.0315843
Skewness	-0.4028886929
Sum	68066.67978
Variance	0.001732878632

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
53.342931	3	0.2%
53.341431	3	0.2%
53.332367	2	0.2%
53.33827	2	0.2%
53.313725	2	0.2%
53.314145	2	0.2%
53.337848	2	0.2%
53.26935	2	0.2%
53.349442	2	0.2%
53.247731	2	0.2%
Other values (1231)	1254	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
53.21904	1	0.1%
53.226358	1	0.1%
53.228438	1	0.1%
53.229695	1	0.1%
53.233244	1	0.1%

Value	Count	Frequency (%)
53.433172	1	0.1%
53.432174	1	0.1%
53.431643	1	0.1%
53.422947	1	0.1%
53.422198	1	0.1%

pricePerBedroom
Real number (ℝ)

Distinct count	298
Unique (%)	23.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	148095.4246902523
Minimum	-1500000.0
Maximum	625000.0
Zeros	0
Zeros (%)	0.0%
Memory size	10.1 KiB

Quantile statistics

Minimum	-1500000
5-th percentile	78333.33333
Q1	108333.3333
median	137916.6667
Q3	185625
95-th percentile	275000
Maximum	625000
Range	2125000
Interquartile range (IQR)	77291.66667

Descriptive statistics

Standard deviation	100595.9864
Coefficient of variation (CV)	0.6792646469
Kurtosis	79.13782629
Mean	148095.4247
Median Absolute Deviation (MAD)	37083.33333
Skewness	-5.543220326
Sum	188969761.9
Variance	1.011955247e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
125000	36	2.8%
150000	31	2.4%
175000	29	2.3%
137500	23	1.8%
187500	21	1.6%
165000	20	1.6%
100000	18	1.4%
95000	18	1.4%
162500	18	1.4%
112500	18	1.4%
Other values (288)	1044	81.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1500000	1	0.1%
-850000	2	0.2%
-745000	1	0.1%
-498000	1	0.1%
-350000	1	0.1%

Value	Count	Frequency (%)
625000	2	0.2%
600000	1	0.1%
497500	1	0.1%
460000	1	0.1%
450000	2	0.2%

deltaAvgPrice
Real number (ℝ)

HIGH CORRELATION

Distinct count	798
Unique (%)	62.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	20002.763963719077
Minimum	-1785392.8571428573
Maximum	484607.14285714284
Zeros	0
Zeros (%)	0.0%
Memory size	10.1 KiB

Quantile statistics

Minimum	-1785392.857
5-th percentile	-276689.4323
Q1	-43461.5957
median	45311.11806
Q3	108650.7878
95-th percentile	274207.0183
Maximum	484607.1429
Range	2270000
Interquartile range (IQR)	152112.3835

Descriptive statistics

Standard deviation	192861.8567
Coefficient of variation (CV)	9.641760363
Kurtosis	19.83974212
Mean	20002.76396
Median Absolute Deviation (MAD)	74549.70238
Skewness	-2.881062237
Sum	25523526.82
Variance	3.719569579e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-20509.09091	8	0.6%
92284.61538	7	0.5%
63767.85714	7	0.5%
339607.1429	6	0.5%
-82715.38462	6	0.5%
67284.61538	6	0.5%
83567.01031	6	0.5%
59252.52525	6	0.5%
103767.8571	6	0.5%
24886.95652	6	0.5%
Other values (788)	1212	95.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1785392.857	2	0.2%
-1585392.857	1	0.1%
-1329304.762	1	0.1%
-1066482.456	1	0.1%
-991812.5	1	0.1%

Value	Count	Frequency (%)
484607.1429	1	0.1%
464607.1429	1	0.1%
434517.5439	1	0.1%
424607.1429	1	0.1%
423517.5439	1	0.1%

deltaMedianPrice
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count	310
Unique (%)	24.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-27913.401253918495
Minimum	-1972500.0
Maximum	345000.0
Zeros	46
Zeros (%)	3.6%
Memory size	10.1 KiB

Quantile statistics

Minimum	-1972500
5-th percentile	-356250
Q1	-71000
median	5000
Q3	65000
95-th percentile	179250
Maximum	345000
Range	2317500
Interquartile range (IQR)	136000

Descriptive statistics

Standard deviation	193840.6495
Coefficient of variation (CV)	-6.944357935
Kurtosis	26.01250583
Mean	-27913.40125
Median Absolute Deviation (MAD)	67000
Skewness	-3.675974581
Sum	-35617500
Variance	3.75741974e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	46	3.6%
25000	26	2.0%
45000	25	2.0%
60000	25	2.0%
-10000	24	1.9%
50000	24	1.9%
75000	22	1.7%
40000	22	1.7%
20000	22	1.7%
15000	21	1.6%
Other values (300)	1019	79.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1972500	2	0.2%
-1772500	1	0.1%
-1405000	1	0.1%
-1175000	1	0.1%
-1072500	2	0.2%

Value	Count	Frequency (%)
345000	1	0.1%
326000	1	0.1%
315000	2	0.2%
305000	1	0.1%
297500	1	0.1%

dublinNorthSouth
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	10.1 KiB

S	666
N	610

Value	Count	Frequency (%)
S	666	52.2%
N	610	47.8%

Length

Max length	1
Mean length	1
Min length	1

Value	Count	Frequency (%)
Uppercase_Letter	2	100.0%

Value	Count	Frequency (%)
Latin	2	100.0%

Value	Count	Frequency (%)
ASCII	2	100.0%

distToCity
Real number (ℝ_≥0)

Distinct count	1245
Unique (%)	97.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.8688657073764485
Minimum	0.09991156306907832
Maximum	17.012878032749462
Zeros	0
Zeros (%)	0.0%
Memory size	10.1 KiB

Quantile statistics

Minimum	0.09991156307
5-th percentile	1.377932311
Q1	3.028898595
median	5.082270001
Q3	8.621259288
95-th percentile	12.09076667
Maximum	17.01287803
Range	16.91296647
Interquartile range (IQR)	5.592360693

Descriptive statistics

Standard deviation	3.472494848
Coefficient of variation (CV)	0.5916807473
Kurtosis	-0.5953562912
Mean	5.868865707
Median Absolute Deviation (MAD)	2.571887899
Skewness	0.5388872222
Sum	7488.672643
Variance	12.05822047

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3.590435795	3	0.2%
2.415355904	3	0.2%
8.940731434	2	0.2%
8.340624342	2	0.2%
8.438129316	2	0.2%
10.88445414	2	0.2%
1.463954511	2	0.2%
1.841780665	2	0.2%
6.879802013	2	0.2%
1.65164596	2	0.2%
Other values (1235)	1254	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.09991156307	1	0.1%
0.1835478493	1	0.1%
0.2065863985	2	0.2%
0.3172734398	1	0.1%
0.3828696698	1	0.1%

Value	Count	Frequency (%)
17.01287803	1	0.1%
16.56325022	1	0.1%
16.47248576	1	0.1%
16.24328956	1	0.1%
15.94972834	1	0.1%

daysSincePublished
Real number (ℝ_≥0)

Distinct count	155
Unique (%)	12.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	79.42398119122257
Minimum	1
Maximum	339
Zeros	0
Zeros (%)	0.0%
Memory size	10.1 KiB

Quantile statistics

Minimum	1
5-th percentile	10.75
Q1	44
median	82
Q3	108
95-th percentile	144
Maximum	339
Range	338
Interquartile range (IQR)	64

Descriptive statistics

Standard deviation	43.61229927
Coefficient of variation (CV)	0.5491074436
Kurtosis	1.980859241
Mean	79.42398119
Median Absolute Deviation (MAD)	30
Skewness	0.5548587998
Sum	101345
Variance	1902.032648

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
54	35	2.7%
74	34	2.7%
103	33	2.6%
87	29	2.3%
115	25	2.0%
106	25	2.0%
94	24	1.9%
38	24	1.9%
114	23	1.8%
67	23	1.8%
Other values (145)	1001	78.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	4	0.3%
2	8	0.6%
3	13	1.0%
4	6	0.5%
5	10	0.8%

Value	Count	Frequency (%)
339	1	0.1%
336	1	0.1%
303	1	0.1%
229	1	0.1%
228	1	0.1%

numFood
Real number (ℝ_≥0)

Distinct count	46
Unique (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	46.405956112852664
Minimum	11
Maximum	60
Zeros	0
Zeros (%)	0.0%
Memory size	10.1 KiB

Quantile statistics

Minimum	11
5-th percentile	30
Q1	42
median	49
Q3	52
95-th percentile	57
Maximum	60
Range	49
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.254563312
Coefficient of variation (CV)	0.1778772383
Kurtosis	1.403756982
Mean	46.40595611
Median Absolute Deviation (MAD)	4
Skewness	-1.14037135
Sum	59214
Variance	68.13781548

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
49	105	8.2%
50	98	7.7%
52	86	6.7%
48	78	6.1%
53	74	5.8%
51	68	5.3%
54	67	5.3%
47	57	4.5%
43	48	3.8%
46	46	3.6%
Other values (36)	549	43.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11	2	0.2%
13	1	0.1%
15	2	0.2%
16	3	0.2%
19	2	0.2%

Value	Count	Frequency (%)
60	5	0.4%
59	16	1.3%
58	26	2.0%
57	30	2.4%
56	32	2.5%

numRecreation
Real number (ℝ_≥0)

Distinct count	23
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	12.52115987460815
Minimum	1
Maximum	23
Zeros	0
Zeros (%)	0.0%
Memory size	10.1 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	10
median	13
Q3	16
95-th percentile	18.25
Maximum	23
Range	22
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.990029602
Coefficient of variation (CV)	0.3186629387
Kurtosis	-0.3872828611
Mean	12.52115987
Median Absolute Deviation (MAD)	3
Skewness	-0.3412107627
Sum	15977
Variance	15.92033622

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
12	165	12.9%
13	130	10.2%
15	121	9.5%
17	105	8.2%
16	97	7.6%
9	92	7.2%
11	90	7.1%
14	89	7.0%
10	66	5.2%
7	58	4.5%
Other values (13)	263	20.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2	0.2%
2	2	0.2%
3	14	1.1%
4	21	1.6%
5	47	3.7%

Value	Count	Frequency (%)
23	1	0.1%
22	1	0.1%
21	3	0.2%
20	21	1.6%
19	38	3.0%

numShop
Real number (ℝ_≥0)

Distinct count	37
Unique (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.244514106583072
Minimum	1
Maximum	37
Zeros	0
Zeros (%)	0.0%
Memory size	10.1 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	4
median	7
Q3	18
95-th percentile	28.25
Maximum	37
Range	36
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	8.636889037
Coefficient of variation (CV)	0.7680980214
Kurtosis	-0.1124810606
Mean	11.24451411
Median Absolute Deviation (MAD)	3
Skewness	1.014075061
Sum	14348
Variance	74.59585223

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	278	21.8%
5	176	13.8%
6	77	6.0%
7	58	4.5%
8	50	3.9%
9	41	3.2%
22	38	3.0%
11	37	2.9%
10	37	2.9%
20	36	2.8%
Other values (27)	448	35.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	8	0.6%
2	34	2.7%
3	23	1.8%
4	278	21.8%
5	176	13.8%

Value	Count	Frequency (%)
37	1	0.1%
36	1	0.1%
35	10	0.8%
34	5	0.4%
33	10	0.8%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	df_index	title	neighbourhood	propertyType	numBedrooms	numBathrooms	floorArea	price	rating	sellerId	longitude	latitude	pricePerBedroom	deltaAvgPrice	deltaMedianPrice	dublinNorthSouth	distToCity	daysSincePublished	numFood	numRecreation	numShop
0	0	1 Moatfield Park, Coolock, Artane, Dublin 5	Dublin 5	Semi-D	3.0	1.0	91	380000.0	E2	453	-6.193117	53.388871	126666.666667	14794.642857	-5000.0	N	5.857172	5	49	17	12
1	9	150 Broadford Rise, Ballinteer, Dublin 16	Dublin 16	Semi-D	3.0	2.0	102	495000.0	C3	49	-6.261108	53.277830	165000.000000	13187.500000	-20000.0	S	8.366932	3	47	9	15
2	11	Apartment 172, Block C, Dublin 7	Dublin 7	Apartment	1.0	1.0	51	250000.0	C1	1331	-6.277584	53.348715	250000.000000	128567.010309	100000.0	N	1.387431	9	53	12	4
3	14	26 Manorfields Walk, Castaheany, Clonee, Dublin 15	Dublin 15	Terrace	2.0	1.0	70	250000.0	D1	1186	-6.424428	53.397586	125000.000000	88767.857143	30000.0	N	12.090038	8	46	8	25
4	16	Ayla, 39 Beach Road, Sandymount, Dublin 4	Dublin 4	Terrace	3.0	4.0	147	950000.0	C1	893	-6.215883	53.335437	316666.666667	-235392.857143	-422500.0	S	3.414646	8	48	19	4
5	41	Apartment 156, Block 6, Harcourt Green, Dublin 2	Dublin 2	Apartment	2.0	2.0	75	399000.0	B3	262	-6.260185	53.331722	199500.000000	16935.483871	-4000.0	S	2.380052	2	51	16	4
6	43	Apt 9 Lucerne, 39 Castle Avenue, Clontarf, Dublin 3	Dublin 3	Apartment	2.0	1.0	55	310000.0	SI_666	11766	-6.207086	53.362925	155000.000000	160695.238095	85000.0	N	3.548787	8	42	20	7
7	50	46 Oxmantown Road, Stoneybatter, Dublin 7	Dublin 7	Terrace	2.0	-1.0	56	280000.0	F	1087	-6.291654	53.353738	140000.000000	98567.010309	70000.0	N	2.233330	15	53	12	4
8	54	71 Parklands Court, Ballycullen, Dublin 16	Dublin 16	Apartment	2.0	1.0	70	255000.0	ZZZ	8210	-6.341428	53.274936	127500.000000	253187.500000	220000.0	S	10.301642	15	28	9	23
9	55	24 The Wood, Millbrook Lawns, Tallaght, Dublin 24	Dublin 24	Terrace	3.0	1.0	90	285000.0	ZZZ	8210	-6.355033	53.281759	95000.000000	-2389.473684	-10000.0	S	10.214784	15	38	7	31

Last rows

	df_index	title	neighbourhood	propertyType	numBedrooms	numBathrooms	floorArea	price	rating	sellerId	longitude	latitude	pricePerBedroom	deltaAvgPrice	deltaMedianPrice	dublinNorthSouth	distToCity	daysSincePublished	numFood	numRecreation	numShop
1266	2924	5 Dun Emer Drive, Dundrum, Dublin 14	Dublin 14	Semi-D	4.0	1.0	138	645000.0	D2	49	-6.236976	53.282698	161250.000000	-49691.489362	-55000.0	S	7.946910	113	48	10	12
1267	2928	133 Kiltipper Gate, Tallaght, Dublin 24	Dublin 24	Apartment	2.0	2.0	70	215000.0	ZZZ	8210	-6.370672	53.269495	107500.000000	67610.526316	60000.0	S	11.927989	15	22	5	20
1268	2930	19 Beneavin Park, Glasnevin, Dublin 11	Dublin 11	Semi-D	3.0	1.0	97	370000.0	D2	841	-6.283289	53.389930	123333.333333	-68213.675214	-95000.0	N	4.422859	95	51	18	4
1269	2935	2 Florence Street, Portobello, Dublin 8	Dublin 8	Terrace	3.0	2.0	124	595000.0	E2	8456	-6.269723	53.331242	198333.333333	-252715.384615	-300000.0	S	2.550457	89	54	15	4
1270	2939	9 Saint Johns Court, Kilmore Road, Artane, Dublin 5	Dublin 5	Terrace	2.0	1.0	71	285000.0	C3	1063	-6.218931	53.390851	142500.000000	109794.642857	90000.0	N	4.930323	24	56	13	8
1271	2950	Apt 4, Slane House, Patrick Street, Christchurch, Dublin 8	Dublin 8	Apartment	1.0	1.0	37	230000.0	E2	6223	-6.272552	53.340047	230000.000000	112284.615385	65000.0	S	1.742339	2	56	11	4
1272	2956	4 Old Mount Pleasant, Ranelagh, Dublin 6	Dublin 6	Terrace	3.0	1.0	154	825000.0	SI_666	262	-6.258158	53.326563	275000.000000	-191482.456140	-300000.0	S	2.948946	3	52	16	5
1273	2958	122 Connaught Street, Phibsborough, Dublin 7	Dublin 7	Terrace	3.0	1.0	100	550000.0	E2	841	-6.279345	53.363448	183333.333333	-171432.989691	-200000.0	N	1.823827	120	57	12	4
1274	2960	10 Ard Na Greine, Eaton Brae, off Orwell Road, Rathgar, Dublin 6	Dublin 6	Terrace	2.0	2.0	144	900000.0	A3	9460	-6.261595	53.303673	450000.000000	-266482.456140	-375000.0	S	5.497794	47	46	18	9
1275	2962	3 Marian Drive, Rathfarnham, Dublin 14	Dublin 14	Detached	5.0	3.0	214	850000.0	C1	11062	-6.296157	53.295243	170000.000000	-254691.489362	-260000.0	S	6.910201	26	50	10	11

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows